<?php 
include_once('connection/connection.php');
include('header.php');
include('menu.php');
include('config.php');
$frm=$_SESSION['form_id'];
$id1=$_SESSION['id1'];
$dis_name=$_SESSION['dis_name'];
$qr="select * from tbl_dtls_q3_loc where form_id='$frm'";
$res=mysql_query($qr);
$row1=mysql_fetch_array($res);
$qr2="select * from tbl_dtls_q3_ranking where loc_id='$id1'";
$res2=mysql_query($qr2);
$row10=mysql_fetch_array($res2);
if(isset($_POST['back']))
{ 
	header('Location: view_q3_5.php');
}	
if(isset($_POST['submit']))
{ 
	header('Location: view_q3_7.php');
}	
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="css/style_question.css" type="text/css" rel="stylesheet" />
<title>View Q3</title>
</head>
<body>
<div align="center">
<form action="" method="post" enctype="multipart/form-data">
	<table border="0" width="100%" id="table1" cellspacing="1" cellpadding="0">
		<tr>
			<td height="30" colspan="2">
			<p align="center">
			<font face="Verdana" style="font-size: 10pt; font-weight: 700" color="#000000">
			Questionnaire No. 3</font></p></td>
		</tr>
		<tr>
			<td height="19" colspan="2">
			<p align="center">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">For 
			Field Survey (Village Level questionnaire) </font></p></td>
		</tr>
		<tr>
			<td height="18" colspan="2">
			<p align="center">
			<font style="font-size: 8.5pt" face="Arial" color="#000000">Page 6</font></p></td>
		</tr>
		<tr>
			<td colspan="2"><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">&nbsp;Form Id = <?php echo $frm?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;District Name = <?php echo $dis_name?></font></span></td>
		</tr>
		<tr><td colspan="2">&nbsp;</td></tr>
		<tr>
			<td height="22" colspan="2" bgcolor="#EEEEEE"><font color="#000000">
			<span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt">&nbsp; 11.&nbsp; 
			Traditional Sources</font></span></font></td>
  		</tr>
		<tr>
			<td height="22" width="149" bgcolor="#F7E6B7">
			<font style="font-size: 8.5pt" face="Verdana" color="#990000">
			&nbsp;Source Type</font></td>
			<td height="22" width="826" bgcolor="#F7E6B7">
			<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
			&nbsp;Total Nos.</font></td>
		</tr>
		<tr>
			<td height="22" width="149">
			<font style="font-size: 9pt" face="Verdana" color="#000000">
			&nbsp;Bawaries</font></td>
			<td width="826" height="22">
		  &nbsp;
		  <label id="baw_no"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row1[baw_no]";?></font></label></td>
		</tr>
		<tr>
            <td colspan="2"><table border="1" width="100%" id="table5" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="46" align="center" bgcolor="#F7E6B7"></td>
					<td width="95" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Location</font></td>
					<td width="75" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Longitude</font></td>
					<td width="69" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Latitude</font></td>
					<td width="123" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Operational Status</font></td>
					<td width="134" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Method of Filling Water</font></td>
					<td width="153" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Are Rain Water Collected</font></td>
					<td width="146" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					How Many Months Water Retained</font></td>
					<td width="95" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Approximate Capacity(cu.m)</font></td>
				</tr>
				<?php
			$qr2="select * from tbl_dtls_q3_traditional_src where loc_id='$id1' and trad_id LIKE 'Bawarie%' order by 0+replace(trad_id,'Bawarie','')";
			$res2=mysql_query($qr2);
			while($row2=mysql_fetch_array($res2))
			{
				?>
				<tr>
				  <td width="46"><label id="trad_id1"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row2[trad_id]";?></font></label></td>
					<td width="95" align="center"><label id="trad_location1"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row2[trad_location]";?></font></label></td>
				  <td width="75" align="center"><label id="trad_longitud1"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row2[trad_longitude]";?></font></label></td>
				  <td width="69" align="center"><label id="trad_latitude1"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row2[trad_latitude]";?></font></label></td>
					<td width="123" align="center"><label id="trad_op_status1"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row2[trad_op_status]";?></font></label></td>
					<td width="134" align="center"><label id="trad_method1"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row2[trad_method]";?></font></label></td>
				  <td width="153" align="center"><label id="trad_rain_water1"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row2[trad_rain_water]";?></font></label></td>
				  <td width="146" align="center"><label id="trad_month1"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row2[trad_month]";?></font></label></td>
					<td width="95" align="center"><label id="trad_approx_cap1"><font style="font-size: 9pt" face="Verdana" color="#000000"><?php echo "$row2[trad_approx_cap]";?></font></label></td>
				</tr>
				<?php 
				}
				?>	
</table></td></tr>
		<tr>
			<td height="22" width="149">
			<font style="font-size: 9pt" face="Verdana" color="#000000">
			&nbsp;Old Open Well</font></td>
	  	  <td width="826" height="22">
	  	  &nbsp;
	  	  <label id="well_no"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row1[well_no]";?></font></label></td>
		</tr>
		<tr>
            <td colspan="2"><table border="1" width="100%" id="table5" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="47" align="center" bgcolor="#F7E6B7"></td>
					<td width="93" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Location</font></td>
					<td width="79" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Longitude</font></td>
				  	<td width="69" align="center" bgcolor="#F7E6B7">
				  	<font face="Verdana" style="font-size: 8.5pt" color="#990000">Latitude</font></td>
					<td width="121" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Operational Status</font></td>
					<td width="136" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Method of Filling Water</font></td>
					<td width="153" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Are Rain Water Collected</font></td>
					<td width="144" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					How Many Months Water Retained</font></td>
					<td width="94" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Approximate Capacity(cu.m)</font></td>
				</tr>
				<?php
			$qr2="select * from tbl_dtls_q3_traditional_src where loc_id='$id1' and trad_id LIKE 'Open Well%' order by 0+replace(trad_id,'Open Well','')";
			$res2=mysql_query($qr2);
			while($row3=mysql_fetch_array($res2))
			{
				?>
				<tr>
				  <td width="47"><label id="trad_id2"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row3[trad_id]";?></font></label></td>
					<td width="93" align="center"><label id="trad_location2"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row3[trad_location]";?></font></label></td>
					<td width="79" align="center"><label id="trad_longitud2"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row3[trad_longitude]";?></font></label></td>
					<td width="69" align="center"><label id="trad_latitude2"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row3[trad_latitude]";?></font></label></td>
				  <td width="121" align="center"><label id="trad_op_status2"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row3[trad_op_status]";?></font></label></td>
				  <td width="136" align="center"><label id="trad_method2"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row3[trad_method]";?></font></label></td>
				  <td width="153" align="center"><label id="trad_rain_water2"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row3[trad_rain_water]";?></font></label></td>
				  <td width="144" align="center"><label id="trad_month2"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row3[trad_month]";?></font></label></td>
				  <td width="94" align="center"><label id="trad_approx_cap2"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row3[trad_approx_cap]";?></font></label></td>
				</tr>
				<?php 
				} 
				?>
</table></td></tr>
		<tr>
			<td height="22" width="149">
			<font style="font-size: 9pt" face="Verdana" color="#000000">
			&nbsp;Public Tankas</font></td>
			<td width="826" height="22">
	  	  &nbsp;
	  	  <label id="tanka_no"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row1[tanka_no]";?></font></label></td>
		</tr>
		<tr>
            <td colspan="2"><table border="1" width="100%" id="table5" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="50" align="center" bgcolor="#F7E6B7"></td>
					<td width="94" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Location</font></td>
					<td width="78" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Longitude</font></td>
				  	<td width="69" align="center" bgcolor="#F7E6B7">
				 	<font face="Verdana" style="font-size: 8.5pt" color="#990000">Latitude</font></td>
					<td width="122" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Operational Status</font></td>
					<td width="134" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Method of Filling Water</font></td>
					<td width="153" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Are Rain Water Collected</font></td>
					<td width="143" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					How Many Months Water Retained</font></td>
					<td width="93" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Approximate Capacity(cu.m)</font></td>
				</tr>
				<?php
			$qr2="select * from tbl_dtls_q3_traditional_src where loc_id='$id1' and trad_id LIKE 'Public Tanka%' order by 0+replace(trad_id,'Public Tanka','')";
			$res2=mysql_query($qr2);
			while($row4=mysql_fetch_array($res2))
			{
				?>
				<tr>
				  <td width="50"><label id="trad_id3"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row4[trad_id]";?></font></label></td>
				  <td width="94" align="center"><label id="trad_location3"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row4[trad_location]";?></font></label></td>
					<td width="78" align="center"><label id="trad_longitud3"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row4[trad_longitude]";?></font></label></td>
					<td width="69" align="center"><label id="trad_latitude3"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row4[trad_latitude]";?></font></label></td>
				  <td width="122" align="center"><label id="trad_op_status3"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row4[trad_op_status]";?></font></label></td>
				  <td width="134" align="center"><label id="trad_method3"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row4[trad_method]";?></font></label></td>
				  <td width="153" align="center"><label id="trad_rain_water3"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row4[trad_rain_water]";?></font></label></td>
				  <td width="143" align="center"><label id="trad_month3"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row4[trad_month]";?></font></label></td>
				  <td width="93" align="center"><label id="trad_approx_cap3"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row4[trad_approx_cap]";?></font></label></td>
				</tr>
				<?php 
				}
				?>	
</table></td></tr>
		<tr>
			<td height="22" width="149">
			<font style="font-size: 9pt" face="Verdana" color="#000000">
			&nbsp;House Hold Tankas</font></td>
			<td width="826" height="22">
		  &nbsp;
		  <label id="house_tanka_no"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row1[house_tanka_no]";?></font></label></td>
		</tr>
		<tr>
            <td colspan="2"><table border="1" width="100%" id="table5" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="51" align="center" bgcolor="#F7E6B7"></td>
					<td width="93" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Location</font></td>
					<td width="81" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Longitude</font></td>
				  	<td width="69" align="center" bgcolor="#F7E6B7">
				  	<font face="Verdana" style="font-size: 8.5pt" color="#990000">Latitude</font></td>
					<td width="120" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Operational Status</font></td>
					<td width="134" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Method of Filling Water</font></td>
					<td width="152" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Are Rain Water Collected</font></td>
					<td width="143" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					How Many Months Water Retained</font></td>
					<td width="93" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Approximate Capacity(cu.m)</font></td>
				</tr>
				<?php
			$qr2="select * from tbl_dtls_q3_traditional_src where loc_id='$id1' and trad_id LIKE 'House Hold Tanka%' order by 0+replace(trad_id,'House Hold Tanka','')";
			$res2=mysql_query($qr2);
			while($row5=mysql_fetch_array($res2))
			{
				?>
				<tr>
				  <td width="51"><label id="trad_id4"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row5[trad_id]";?></font></label></td>
					<td width="93" align="center"><label id="trad_location4"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row5[trad_location]";?></font></label></td>
					<td width="81" align="center"><label id="trad_longitud4"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row5[trad_longitude]";?></font></label></td>
					<td width="69" align="center"><label id="trad_latitude4"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row5[trad_latitude]";?></font></label></td>
				  <td width="120" align="center"><label id="trad_op_status4"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row5[trad_op_status]";?></font></label></td>
				  <td width="134" align="center"><label id="trad_method4"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row5[trad_method]";?></font></label></td>
				  <td width="152" align="center"><label id="trad_rain_water4"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row5[trad_rain_water]";?></font></label></td>
				  <td width="143" align="center"><label id="trad_month4"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row5[trad_month]";?></font></label></td>
				  <td width="93" align="center"><label id="trad_approx_cap4"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row5[trad_approx_cap]";?></font></label></td>
				</tr>
				<?php 
				 }
				?>	
</table></td></tr>
		<tr>
			<td height="22" width="149">
			<font style="font-size: 9pt" face="Verdana" color="#000000">
			&nbsp;Ponds Pucca</font></td>
			<td width="826" height="22">
	  	  &nbsp;
	  	  <label id="pucca_no"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row1[pucca_no]";?></font></label></td>
		</tr>
		<tr>
            <td colspan="2"><table border="1" width="100%" id="table5" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="52" align="center" bgcolor="#F7E6B7"></td>
					<td width="92" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Location</font></td>
					<td width="82" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Longitude</font></td>
				  	<td width="70" align="center" bgcolor="#F7E6B7">
				  	<font face="Verdana" style="font-size: 8.5pt" color="#990000">Latitude</font></td>
					<td width="120" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Operational Status</font></td>
					<td width="133" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Method of Filling Water</font></td>
					<td width="150" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Are Rain Water Collected</font></td>
					<td width="143" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					How Many Months Water Retained</font></td>
					<td width="94" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Approximate Capacity(cu.m)</font></td>
				</tr>
				<?php
			$qr2="select * from tbl_dtls_q3_traditional_src where loc_id='$id1' and trad_id LIKE 'Pond Pucca%' order by 0+replace(trad_id,'Pond Pucca','')";
			$res2=mysql_query($qr2);
			while($row6=mysql_fetch_array($res2))
			{
				?>
				<tr>
				  <td width="52"><label id="trad_id5"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row6[trad_id]";?></font></label></td>
					<td width="92" align="center"><label id="trad_location5"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row6[trad_location]";?></font></label></td>
					<td width="82" align="center"><label id="trad_longitud5"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row6[trad_longitude]";?></font></label></td>
				  <td width="70" align="center"><label id="trad_latitude5"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row6[trad_latitude]";?></font></label></td>
				  <td width="120" align="center"><label id="trad_op_status5"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row6[trad_op_status]";?></font></label></td>
				  <td width="133" align="center"><label id="trad_method5"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row6[trad_method]";?></font></label></td>
				  <td width="150" align="center"><label id="trad_rain_water5"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row6[trad_rain_water]";?></font></label></td>
				  <td width="143" align="center"><label id="trad_month5"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row6[trad_month]";?></font></label></td>
				  <td width="94" align="center"><label id="trad_approx_cap5"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row6[trad_approx_cap]";?></font></label></td>
				</tr>
				<?php 
				 }
				?>
</table></td></tr>
		<tr>
			<td height="22" width="149">
			<font style="font-size: 9pt" face="Verdana" color="#000000">
			&nbsp;Ponds Kachha</font></td>
			<td width="826" height="22">
	  	  &nbsp;
	  	  <label id="kachha_no"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row1[kachha_no]";?></font></label></td>
		</tr>
		<tr>
            <td colspan="2"><table border="1" width="100%" id="table5" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="53" align="center" bgcolor="#F7E6B7"></td>
					<td width="90" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Location</font></td>
					<td width="85" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Longitude</font></td>
				  	<td width="70" align="center" bgcolor="#F7E6B7">
				  	<font face="Verdana" style="font-size: 8.5pt" color="#990000">Latitude</font></td>
					<td width="121" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Operational Status</font></td>
					<td width="134" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Method of Filling Water</font></td>
					<td width="149" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Are Rain Water Collected</font></td>
					<td width="143" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					How Many Months Water Retained</font></td>
					<td width="91" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Approximate Capacity(cu.m)</font></td>
				</tr>
				<?php
			$qr2="select * from tbl_dtls_q3_traditional_src where loc_id='$id1' and trad_id LIKE 'Pond Kachha%' order by 0+replace(trad_id,'Pond Kachha','')";
			$res2=mysql_query($qr2);
			while($row7=mysql_fetch_array($res2))
			{
				?>
				<tr>
				  <td width="53"><label id="trad_id6"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row7[trad_id]";?></font></label></td>
					<td width="90" align="center"><label id="trad_location6"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row7[trad_location]";?></font></label></td>
					<td width="85" align="center"><label id="trad_longitud6"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row7[trad_longitude]";?></font></label></td>
					<td width="70" align="center"><label id="trad_latitude6"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row7[trad_latitude]";?></font></label></td>
					<td width="121" align="center"><label id="trad_op_status6"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row7[trad_op_status]";?></font></label></td>
					<td width="134" align="center"><label id="trad_method6"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row7[trad_method]";?></font></label></td>
				  <td width="149" align="center"><label id="trad_rain_water6"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row7[trad_rain_water]";?></font></label></td>
				  <td width="143" align="center"><label id="trad_month6"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row7[trad_month]";?></font></label></td>
					<td width="91" align="center"><label id="trad_approx_cap6"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row7[trad_approx_cap]";?></font></label></td>
				</tr>
				<?php 
				 }
				?>		
</table></td></tr>
		<tr>
			<td height="22" width="149">
			<font style="font-size: 9pt" face="Verdana" color="#000000">
			&nbsp;Canal Water Ponds</font></td>
			<td width="826" height="22">
	  	  &nbsp;
	  	  <label id="canal_no"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row1[canal_no]";?></font></label></td>
		</tr>
		<tr>
            <td colspan="2"><table border="1" width="100%" id="table5" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="51" align="center" bgcolor="#F7E6B7"></td>
					<td width="93" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Location</font></td>
					<td width="85" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Longitude</font></td>
					<td width="72" align="center" bgcolor="#F7E6B7">
					<font face="Verdana" style="font-size: 8.5pt" color="#990000">Latitude</font></td>
					<td width="119" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Operational Status</font></td>
					<td width="134" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Method of Filling Water</font></td>
					<td width="150" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					Are Rain Water Collected</font></td>
					<td width="139" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">					
					How Many Months Water Retained</font></td>
					<td width="93" align="center" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt" face="Verdana" color="#990000">
					Approximate Capacity(cu.m)</font></td>
				</tr>
				<?php
			$qr2="select * from tbl_dtls_q3_traditional_src where loc_id='$id1' and trad_id LIKE 'Canal%' order by 0+replace(trad_id,'Canal','')";
			$res2=mysql_query($qr2);
			while($row8=mysql_fetch_array($res2))
			{
				?>
				<tr>
				  <td width="51"><label id="trad_id7"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row8[trad_id]";?></font></label></td>
				  <td width="93" align="center"><label id="trad_location7"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row8[trad_location]";?></font></label></td>
					<td width="85" align="center"><label id="trad_longitud7"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row8[trad_longitude]";?></font></label></td>
					<td width="72" align="center"><label id="trad_latitude7"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row8[trad_latitude]";?></font></label></td>
				  <td width="119" align="center"><label id="trad_op_status7"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row8[trad_op_status]";?></font></label></td>
				  <td width="134" align="center"><label id="trad_method7"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row8[trad_method]";?></font></label></td>
				  <td width="150" align="center"><label id="trad_rain_water7"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row8[trad_rain_water]";?></font></label></td>
				  <td width="139" align="center"><label id="  	trad_month7"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row8[trad_month]";?></font></label></td>
				  <td width="93" align="center"><label id="trad_approx_cap7"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row8[trad_approx_cap]";?></font></label></td>
				</tr>
				<?php 
				}
				?>	
</table></td></tr>
		<tr>
			<td colspan="2">&nbsp;</td>
		</tr>
	</table>
		<table width="100%" border="1" cellpadding="1" cellspacing="1" bgcolor="#FDF9EE" id="table6" style="border-collapse:collapse; border-color:#99CCCC;">
            <tr>
			<td height="22" colspan="8" bgcolor="#EEEEEE"><font color="#000000">
			<span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt">&nbsp; 12.&nbsp; Tanker supply</font></span></font></td>
			</tr>
			<tr>
			<td width="145" height="23" bgcolor="#F7E6B7" align="center"><address>
                <font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"> Habitation Name</font>
              </address></td> 
				<td align="center" width="56" rowspan="" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
			  Type MH/ OH</font></address></td>
              <td height="23" bgcolor="#F7E6B7" align="center" width="102"><address>
                <font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"> Owned By</font>
              </address></td>
              <td height="23" bgcolor="#F7E6B7" align="center" colspan="0"><address>
                <font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"> Time of Supply</font>
              </address></td>
              <td height="23" colspan="0" bgcolor="#F7E6B7" align="center"><address>
                <font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"> Type of Tanker</font>
              </address></td>
              <td width="176" height="46" rowspan="0" bgcolor="#F7E6B7" align="center"><address>
                <font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"> Frequency of supply per day               </font>
              </address></td>
			  
              <td height="23" bgcolor="#F7E6B7" align="center" colspan="0"><address>
                <font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"> Reason for tanker Supply</font>
              </address></td>
              <td height="23" bgcolor="#F7E6B7" align="center" colspan="0"><address>
                <font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000"> Population served </font>
              </address></td>
            </tr>
            <?php
			$qr2="select * from tbl_dtls_q3_tanker_supply where loc_id='$id1' order by habit_code asc";
			$res2=mysql_query($qr2);
			while($row9=mysql_fetch_array($res2))
			{
				?>
            <tr>
              <td width="145" align="center" cellspacing="1">
				<label id="habit_name"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row9[habit_name]";?></font></label></td>
			  <td align="center" width="56">
			  <label id="type_habit"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row9[type_habit]";?></font></label></td>
              <td width="102" align="center" cellspacing="1">
			  <label id="body_supply"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row9[body_supply]";?></font></label></td>
              <td width="97" align="center" cellspacing="1">
			  <label id="time_supply"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row9[time_supply]";?></font></label></td>
              <td width="98" align="center" cellspacing="1">
			  <label id="type_tanker"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row9[type_tanker]";?></font></label></td>
              <td width="176" align="center" cellspacing="1">
			  <label id="freq_supply_day"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row9[freq_supply_day]";?></font></label></td>
              <td align="center" width="148" cellspacing="1">
			  <label id="reason_tanker_supply"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row9[reason_tanker_supply]";?></font></label></td>
              <td align="center" width="131" cellspacing="1">
			  <label id="population_served"><font face="Verdana" style="font-size: 8.5pt"><?php echo "$row9[population_served]";?></font></label></td>
            </tr>
            <?php }?>
		
		</table>
		<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#FDF9EE" id="table6" style="border-collapse:collapse; border-color:#99CCCC;">
		<tr>
			<td height="22" colspan="2" bgcolor="#EEEEEE"><font color="#000000">
			<span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt">&nbsp; 13.&nbsp; </font></span></font><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">Please 
			Rank the felt needs of community in the order of priority (for main 
			Village)</font></span></td>
		</tr>
		<tr>
			<td height="22" colspan="2" bgcolor="#EEEEEE">
			<span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#FF0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Enter 1 to 11 in the boxes for ranking (priority)</font></span></td>
		</tr>
		<tr>
			<td colspan="2">
			<table border="1" width="100%" id="table8" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td width="70" align="center">
					<label id="not_suffic_water_available"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[not_suffic_water_available]";?></font></label></td>
					<td width="748">
					<font style="font-size: 9pt" face="Verdana" color="#000000">&nbsp;&nbsp
					Not sufficient quantity of water available</font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="quality_water_not_good"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[quality_water_not_good]";?></font></label></td>
					<td>
					<font style="font-size: 9pt" face="Verdana" color="#000000">&nbsp;&nbsp
					Quality of water is not good for drinking</font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="large_dist_travel"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[large_dist_travel]";?></font></label></td>
					<td>
					<font style="font-size: 9pt" face="Verdana" color="#000000">&nbsp;&nbsp
					Large distance to travel</font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="lmtd_water_supply"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[lmtd_water_supply]";?></font></label></td>
					<td>
					<font face="Verdana" style="font-size: 9pt" color="#000000">&nbsp;&nbsp
					Very limited time to supply</font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="traditional_system_rejuvenated"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[traditional_system_rejuvenated]";?></font></label></td>
					<td>
					<font style="font-size: 9pt" face="Verdana" color="#000000">&nbsp;&nbsp
					Existing traditional system rejuvenated </font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="handpump_needed"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[handpump_needed]";?></font></label></td>
					<td>
					<font face="Verdana" style="font-size: 9pt" color="#000000">&nbsp;&nbsp
					More hand pumps are needed</font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="roof_water_harvest"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[roof_water_harvest]";?></font></label></td>
					<td>
					<font style="font-size: 9pt" face="Verdana" color="#000000">&nbsp;&nbsp
					Roof water Harvesting</font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="water_through_ponds_req"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[water_through_ponds_req]";?></font></label></td>
					<td>
					<font style="font-size: 9pt" face="Verdana" color="#000000">&nbsp;&nbsp
					Water conservation through ponds is required</font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="water_facility_sc_st"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[water_facility_sc_st]";?></font></label></td>
					<td>
					<font style="font-size: 9pt" face="Verdana" color="#000000">&nbsp;&nbsp
					Water facility in SC/ ST basti</font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="water_supply_govt_school"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[water_supply_govt_school]";?></font></label></td>
					<td>
					<font style="font-size: 9pt" face="Verdana" color="#000000">&nbsp;&nbsp
					Water supply in govt school</font></td>
				</tr>
				<tr>
					<td width="70" align="center">
					<label id="water_supply_oh"><font face="Arial" style="font-size: 8.5pt"><?php echo "$row10[water_supply_oh]";?></font></label></td>
					<td>
					<font style="font-size: 9pt" face="Verdana" color="#000000">&nbsp;&nbsp
					Water supply for other habitations </font></td>
				</tr>
			</table></td></tr>
		<tr>
			<td colspan="2">&nbsp;</td>
		</tr>
		<tr>
			<td height="22" colspan="2" bgcolor="#EEEEEE"><font color="#000000">
			<span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt">&nbsp; 14 a).&nbsp; </font></span></font><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">Do the Schools & Anganvadis in the villages / Other Habitations you visit Toilet provisions: &nbsp;&nbsp;&nbsp; <?php echo "$row1[toilet]";?></font></span></td>
		</tr>
		<tr bgcolor="#FDF9EE">
			<td width="166" align="center">
				<label id="toilet"></label></td>
		</tr>
		<tr><td colspan="2">&nbsp;</td></tr>
		<tr>
			<td height="24" colspan="2" bgcolor="#EEEEEE"><font color="#000000">
			<span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt">&nbsp; 14 b).&nbsp; </font></span></font><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">If Yes, Do they have seperate toilets for Boys and girls? &nbsp;&nbsp;<?php echo "$row1[sep_toilet]";?></font></span></td>
		</tr>
		<tr bgcolor="#FDF9EE">
			<td width="166" align="center"><label id="sep_toilet"></label></td>
		</tr>
		<tr><td colspan="2">&nbsp;</td></tr>
		<tr>
			<td colspan="2" align="center">
			<input type="submit" value="Back" name="back" style="font-size: 8pt;font-family:Verdana; border-style: solid; border-width: 1px">&nbsp;&nbsp;
			<input type="submit" value="Next" name="submit" style="font-size: 8pt; font-family: Verdana; border-style: solid; border-width: 1px"></td>
		</tr>
		<tr>
			<td colspan="2">&nbsp;</td>
		</tr>
</table>
</form>
</div>
</body>
</html>